home *** CD-ROM | disk | FTP | other *** search
/ Windows 95 API Bible / Windows 95 API Bible 3 Disc Set.iso / Win32 API Bible Book 3 of 3.iso / chapter5 / stmtopts.c < prev    next >
C/C++ Source or Header  |  1996-04-27  |  10KB  |  283 lines
  1.  
  2. #include <windows.h>  
  3. #include <stdio.h>
  4. #include "stmtopts.h"
  5. #include "sqlext.h"  
  6. #include "odbcinst.h"  
  7.  
  8.  
  9. #if defined (WIN32)
  10.     #define IS_WIN32 TRUE
  11. #else
  12.     #define IS_WIN32 FALSE
  13. #endif
  14.  
  15. #define IS_NT      IS_WIN32 && (BOOL)(GetVersion() < 0x80000000)
  16. #define IS_WIN32S  IS_WIN32 && (BOOL)(!(IS_NT) && (LOBYTE(LOWORD(GetVersion()))<4))
  17. #define IS_WIN95   (BOOL)(!(IS_NT) && !(IS_WIN32S)) && IS_WIN32
  18.  
  19. HINSTANCE hInst;   // current instance
  20.  
  21. LPCTSTR lpszAppName = "MyApp";
  22. LPCTSTR lpszTitle   = "SQLSetStmtOption()"; 
  23.  
  24.  
  25. BOOL RegisterWin95( CONST WNDCLASS* lpwc );
  26.  
  27.  
  28. int APIENTRY WinMain( HINSTANCE hInstance, HINSTANCE hPrevInstance,
  29.                       LPTSTR lpCmdLine, int nCmdShow)
  30. {
  31.    MSG      msg;
  32.    HWND     hWnd; 
  33.    WNDCLASS wc;
  34.  
  35.    wc.style         = CS_HREDRAW | CS_VREDRAW;
  36.    wc.lpfnWndProc   = (WNDPROC)WndProc;       
  37.    wc.cbClsExtra    = 0;                      
  38.    wc.cbWndExtra    = 0;                      
  39.    wc.hInstance     = hInstance;              
  40.    wc.hIcon         = LoadIcon (hInstance, lpszAppName); 
  41.    wc.hCursor       = LoadCursor(NULL, IDC_ARROW);
  42.    wc.hbrBackground = (HBRUSH)(COLOR_WINDOW+1);
  43.    wc.lpszMenuName  = lpszAppName;              
  44.    wc.lpszClassName = lpszAppName;              
  45.  
  46.    if ( IS_WIN95 )
  47.    {
  48.       if ( !RegisterWin95( &wc ) )
  49.          return( FALSE );
  50.    }
  51.    else if ( !RegisterClass( &wc ) )
  52.       return( FALSE );
  53.  
  54.    hInst = hInstance; 
  55.  
  56.    hWnd = CreateWindow( lpszAppName, 
  57.                         lpszTitle,    
  58.                         WS_OVERLAPPEDWINDOW, 
  59.                         CW_USEDEFAULT, 0, 
  60.                         CW_USEDEFAULT, 0,  
  61.                         NULL,              
  62.                         NULL,              
  63.                         hInstance,         
  64.                         NULL               
  65.                       );
  66.  
  67.    if ( !hWnd ) 
  68.       return( FALSE );
  69.  
  70.    ShowWindow( hWnd, nCmdShow ); 
  71.    UpdateWindow( hWnd );         
  72.  
  73.    while( GetMessage( &msg, NULL, 0, 0) )   
  74.    {
  75.       TranslateMessage( &msg ); 
  76.       DispatchMessage( &msg );  
  77.    }
  78.  
  79.    return( msg.wParam ); 
  80. }
  81.  
  82.  
  83. BOOL RegisterWin95( CONST WNDCLASS* lpwc )
  84. {
  85.    WNDCLASSEX wcex;
  86.  
  87.    wcex.style         = lpwc->style;
  88.    wcex.lpfnWndProc   = lpwc->lpfnWndProc;
  89.    wcex.cbClsExtra    = lpwc->cbClsExtra;
  90.    wcex.cbWndExtra    = lpwc->cbWndExtra;
  91.    wcex.hInstance     = lpwc->hInstance;
  92.    wcex.hIcon         = lpwc->hIcon;
  93.    wcex.hCursor       = lpwc->hCursor;
  94.    wcex.hbrBackground = lpwc->hbrBackground;
  95.    wcex.lpszMenuName  = lpwc->lpszMenuName;
  96.    wcex.lpszClassName = lpwc->lpszClassName;
  97.  
  98.    // Added elements for Windows 95.
  99.    //...............................
  100.    wcex.cbSize = sizeof(WNDCLASSEX);
  101.    wcex.hIconSm = LoadImage(wcex.hInstance, lpwc->lpszClassName, 
  102.                             IMAGE_ICON, 16, 16,
  103.                             LR_DEFAULTCOLOR );
  104.             
  105.    return RegisterClassEx( &wcex );
  106. }
  107.  
  108.  
  109. LRESULT CALLBACK WndProc( HWND hWnd, UINT uMsg, WPARAM wParam, LPARAM lParam )
  110. {
  111. static HENV  hEnv  = NULL;
  112. static HDBC  hDBC  = NULL;
  113. static HWND  hList = NULL;
  114.  
  115.    switch( uMsg )
  116.    {
  117.       case WM_CREATE :
  118.               {
  119.                  RETCODE retCode;
  120.  
  121.                  // Allocate Environment and Connection.
  122.                  //.....................................
  123.                  SQLAllocEnv( &hEnv );
  124.                  SQLAllocConnect( hEnv, &hDBC );
  125.  
  126.                  // Connect to the data source
  127.                  //...........................
  128.                  retCode = SQLConnect( hDBC, 
  129.                              "Test Data Source", SQL_NTS,
  130.                              "DBA",              SQL_NTS,  
  131.                              "SQL",              SQL_NTS );
  132.  
  133.                  if ( retCode == SQL_SUCCESS )
  134.                  {
  135.                     int nTabSize = 60;
  136.  
  137.                     hList = CreateWindow( "LISTBOX", "",    
  138.                                LBS_NOTIFY | LBS_USETABSTOPS |
  139.                                LBS_NOINTEGRALHEIGHT  | 
  140.                                WS_BORDER  | WS_CHILD | 
  141.                                WS_VISIBLE | WS_VSCROLL, 
  142.                                0, 0, 0, 0, 
  143.                                hWnd, (HMENU)101,
  144.                                hInst, NULL );
  145.                     
  146.                     SendMessage( hList, LB_SETTABSTOPS, 
  147.                                  1, (LPARAM)&nTabSize );
  148.                  }
  149.               }
  150.               break;
  151.  
  152.       case WM_SIZE :
  153.               MoveWindow( hList, 0, 0, LOWORD( lParam ), 
  154.                                        HIWORD( lParam ), TRUE );
  155.               break; 
  156.               
  157.       case WM_COMMAND :
  158.               switch( LOWORD( wParam ) )
  159.               {
  160.                  case IDM_TEST :
  161.                         {
  162.                            HSTMT   hStmt;
  163.                            ULONG   vParam;    
  164.                            RETCODE retCode;
  165.  
  166.                            // Allocate a statement handle.
  167.                            // ............................
  168.                            SQLAllocStmt( hDBC, &hStmt );
  169.  
  170.                            // Call SQLSetStmtOption() to set 
  171.                            // the concurrency to read only.
  172.                            // ..............................
  173.                            retCode = SQLSetStmtOption( hStmt,
  174.                               SQL_CONCURRENCY, SQL_CONCUR_READ_ONLY ); 
  175.  
  176.                            // Call SQLGetStmtOption() to retrieve
  177.                            // the concurrency option we set.
  178.                            // ...................................
  179.                            if( retCode == SQL_SUCCESS || 
  180.                                retCode == SQL_SUCCESS_WITH_INFO )
  181.                            {
  182.                               retCode = SQLGetStmtOption( hStmt, 
  183.                                                           SQL_CONCURRENCY,
  184.                                                          &vParam );
  185.  
  186.                               if( retCode == SQL_SUCCESS || 
  187.                                   retCode == SQL_SUCCESS_WITH_INFO )
  188.                               {
  189.                                  switch( vParam )
  190.                                  {
  191.                                     case SQL_CONCUR_READ_ONLY:
  192.                                        SendMessage( hList, LB_ADDSTRING, 
  193.                                           0, (LPARAM)"SQL_CONCUR_READ_ONLY" );
  194.                                        break;
  195.  
  196.                                      case SQL_CONCUR_LOCK:
  197.                                        SendMessage( hList, LB_ADDSTRING, 
  198.                                           0, (LPARAM)"SQL_CONCUR_LOCK" );
  199.                                        break;
  200.  
  201.                                      case SQL_CONCUR_ROWVER:
  202.                                        SendMessage( hList, LB_ADDSTRING, 
  203.                                           0, (LPARAM)"SQL_CONCUR_ROWVER" );
  204.                                        break;
  205.  
  206.                                      case SQL_CONCUR_VALUES:
  207.                                        SendMessage( hList, LB_ADDSTRING, 
  208.                                           0, (LPARAM)"SQL_CONCUR_VALUES" );
  209.                                        break;
  210.                                  }
  211.                               }
  212.                               else
  213.                               {
  214.                                  SendMessage( hList, LB_ADDSTRING, 
  215.                                     0, (LPARAM)"SQLGetStmtOption() failed." );
  216.                               }
  217.                            }
  218.                            else
  219.                            {
  220.                               SendMessage( hList, LB_ADDSTRING, 
  221.                                  0, (LPARAM)"SQLSetStmtOption() failed." );
  222.                            }
  223.  
  224.                            // Free the statement handle.
  225.                            // ..........................
  226.                            SQLFreeStmt( hStmt, SQL_DROP );
  227.                         }
  228.                         break;
  229.  
  230.                  case IDM_ABOUT :
  231.                         DialogBox( hInst, "AboutBox", hWnd, (DLGPROC)About );
  232.                         break;
  233.  
  234.                  case IDM_EXIT :
  235.                         DestroyWindow( hWnd );
  236.                         break;
  237.               }
  238.               break;
  239.       
  240.       case WM_DESTROY :
  241.               PostQuitMessage(0);
  242.  
  243.               // Disconnect Environment.
  244.               //........................
  245.               SQLDisconnect( hDBC );
  246.  
  247.               // Free Connection and Environment.
  248.               //.................................
  249.               SQLFreeConnect( hDBC );
  250.               SQLFreeEnv( hEnv );
  251.               break;
  252.  
  253.       default :
  254.             return( DefWindowProc( hWnd, uMsg, wParam, lParam ) );
  255.    }
  256.  
  257.    return( 0L );
  258. }
  259.  
  260.  
  261. LRESULT CALLBACK About( HWND hDlg,           
  262.                         UINT message,        
  263.                         WPARAM wParam,       
  264.                         LPARAM lParam)
  265. {
  266.    switch (message) 
  267.    {
  268.        case WM_INITDIALOG: 
  269.                return (TRUE);
  270.  
  271.        case WM_COMMAND:                              
  272.                if (   LOWORD(wParam) == IDOK         
  273.                    || LOWORD(wParam) == IDCANCEL)    
  274.                {
  275.                        EndDialog(hDlg, TRUE);        
  276.                        return (TRUE);
  277.                }
  278.                break;
  279.    }
  280.  
  281.    return (FALSE); 
  282. }
  283.